USE [DTP]
GO

/****** Object:  StoredProcedure [dbo].[UpdateVehicleCard]    Script Date: 11/26/2010 16:48:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[UpdatePersonCard]
	@id bigint,
	
	@accidentMemberType int = NULL,
	@vehicleNumber int = NULL,
	@escape int = NULL,
	@fullName nvarchar(100) = NULL,
	@driverLicenceId nvarchar(50) = NULL,
	@gender int = NULL,
	@birthday DATETIME2 = NULL,
	@driverExperience int = NULL,
	@drivingTime int = NULL,
	@socialType int = NULL,
	@consequencesType int = NULL,
	@nation int = NULL,
	@livingPlace nvarchar(100) = NULL,
	@violationsOfTrafficLaw int = NULL
	
AS
BEGIN
	SET NOCOUNT ON;
		
    UPDATE dbo.t_PersonCards 
    SET 
    		accidentMemberType = @accidentMemberType,
			vehicleNumber = @vehicleNumber,
			[escape] = @escape,
			fullName = @fullName,
			driverLicenceId = @driverLicenceId,
			gender = @gender,
			birthday = @birthday,
			driverExperience = @driverExperience,
			drivingTime = @drivingTime,
			socialType = @socialType,
			consequencesType = @consequencesType,
			nation = @nation,
			livingPlace = @livingPlace,
			violationsOfTrafficLaw = @violationsOfTrafficLaw
    WHERE id = @id;
END



GO


